2013-04-08 - 5910.200 - Rel Notes - Contracts - Release 021 #BIReleases2013

Release Notes:

5910.200 - Contracts - EPM240

Admin Info


Purpose
Including Contract Information in EPM240 - Silhouette Scorecard
Release No
021
Submitted
04-08-2013
Submitted by
Mallareddy D
Source/Destination Systems
IT > BMS > Quality > Contracts to IT > BMS > Production > Contracts in SAP BO BI 4.0 Dev Environment
Release Sent To
Mark Harris
Object(s) Created By
Narendra Koraganji
Object(s) Tested By
Narendra Koraganji

‍Report Name


EPM240 - Silhouette Scorecard

BEx Query


ZMP_OPASA_Q001
ZMP_OPASA_Q003
ZMP_OPASA_Q004
ZMP_OPASA_Q005
ZMP_OPASA_Q006
ZMP_OPASA_Q007
ZMP_OPASA_Q009
ZMP_OPASA_Q010
ZMP_OPASA_Q011
ZMP_OPASA_Q012

‍NEC Crystal Reports Standards Check


1. EPM240 has been successfully checked against the NEC Crystal Reports Standards Checklist.
2. EPM240 NEC CR checklist has been sent to NEC and also attached here for reference:
EPM240 NEC CR Standard Check List.xlsx

Summary Level Check


Test Conducted

Group: North America
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Current Year Shipped YTD
65,895,548
65,895,548
Pass
2
Last Year Shipped YTD
49,535,432
49,535,432
Pass
3
Current Year Budget YTD
81,480,846
81,480,846
Pass
4
Total Open Revenue
128,132,426
128,132,426
Pass
5
Total Shipped Current Year
194,027,973
194,027,973
Pass
6
Total Shipped Last Year
447,596,834
447,596,834
Pass
7
Total Budget Current Year
516,707,703
516,707,703
Pass
8
TY Quantity
5,913,844
5,913,844
Pass
9
LY Quantity
4,735,464
4,735,464
Pass
10
Budget Quantity
0
0
Pass

License Subreport: MLB PROPERTIES
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Current Year Shipped YTD
36,077,617
36,077,617
Pass
2
Open
40,517,831
40,517,831
Pass
3
Total Revenue YTD
76,595,448
76,595,448
Pass
4
Last Year Shipped YTD
30,673,492
30,673,492
Pass
5
Current Year Budget YTD
41,006,366
41,006,366
Pass
6
TY Quantity
3,041,465
3,041,465
Pass
7
LY Quantity
2,539,906
2,539,906
Pass
8
Budget Quantity
0
0
Pass

Customer Segment Subreport : TASTEMAKER
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Current Year Shipped YTD
471,637
471,637
Pass
2
Open
624,915
624,915
Pass
3
Total Revenue YTD
1,096,552
1,096,552
Pass
4
Last Year Shipped YTD
212,261
212,261
Pass
5
Current Year Budget YTD
0
0
Pass
6
TY Quantity
37,264
37,264
Pass
7
LY Quantity
15,650
15,650
Pass
8
Budget Quantity
0
0
Pass

Customer Subreport : LIDS INC
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
15,119,373
15,119,373
Pass
2
Open
27,515,165
27,515,165
Pass
3
Total
42,634,538
42,634,538
Pass
4
Last Year
11,489,793
11,489,793
Pass
5
Budget
0
0
Pass
6
TY Quantity
1,202,231
1,202,231
Pass
7
LY Quantity
931,121
931,121
Pass
8
Budget Quantity
0
0
Pass

Collection Subreport : CUSTOM
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
14,315,104
14,315,104
Pass
2
Open
38,401,326
38,401,326
Pass
3
Total
52,716,430
52,716,430
Pass
4
Last Year
10,890,258
10,890,258
Pass
5
Budget
0
0
Pass
6
TY Quantity
1,880,401
1,880,401
Pass
7
LY Quantity
1,490,916
1,490,916
Pass
8
Budget Quantity
0
0
Pass

Current Month Reports:
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Current Year Shipped MTD
42,158,008
42,158,008
Pass
2
Last Year Shipped MTD
34,323,003
34,323,003
Pass
3
Budget Current Year MTD
0
0
Pass
4
TY Quantity Current Year MTD
3,649,036
3,649,036
Pass
5
LY Quantity Last Year MTD
3,201,655
3,201,655
Pass
6
Budget Quantity Current Year MTD
0
0
Pass

License Subreport: NFL PROPERTIES
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Current Year Shipped YTD
4,554,961
4,554,961
Pass
2
Open
0
0
Pass
3
Total Revenue YTD
4,554,961
4,554,961
Pass
4
Last Year Shipped YTD
587,086
587,086
Pass
5
Current Year Budget YTD
13,600,821
13,600,821
Pass
6
TY Quantity
344,615
344,615
Pass
7
LY Quantity
96,617
96,617
Pass
8
Budget Quantity
0
0
Pass

Customer Segment Month Subreport : GOLDSTAR
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Current Year Shipped YTD
1,401,306
1,401,306
Pass
2
Open
0
0
Pass
3
Total Revenue YTD
1,401,306
1,401,306
Pass
4
Last Year Shipped YTD
1,629,535
1,629,535
Pass
5
Current Year Budget YTD
0
0
Pass
6
TY Quantity
106,094
106,094
Pass
7
LY Quantity
119,117
119,117
Pass
8
Budget Quantity
0
0
Pass

Customer Month Subreport : CHAMPS DIVISION
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
1,746,159
1,746,159
Pass
2
Open
0
0
Pass
3
Total
1,746,159
1,746,159
Pass
4
Last Year
3,015,394
3,015,394
Pass
5
Budget
0
0
Pass
8
TY Quantity
135,758
135,758
Pass
9
LY Quantity
243,398
243,398
Pass
10
Budget Quantity
0
0
Pass

Collection Month Subreport : CUSTOM 5950
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
4,364,304
4,364,304
Pass
2
Open
13,677
13,677
Pass
3
Total
4,377,982
4,377,982
Pass
4
Last Year
4,253,290
4,253,290
Pass
5
Budget
0
0
Pass
8
TY Quantity
337,462
337,462
Pass
9
LY Quantity
333,224
333,224
Pass
10
Budget Quantity
0
0
Pass

Second Level Check


Test Conducted

Group: North America > 5950
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Current Year Shipped YTD
57,084,379
57,084,379
Pass
2
Last Year Shipped YTD
59,313,228
59,313,228
Pass
3
Current Year Budget YTD
72,387,244
72,387,244
Pass
4
Total Open Revenue
39,731,879
39,731,879
Pass
5
Total Shipped Current Year
96,816,258
96,816,258
Pass
6
Total Shipped Last Year
220,852,116
220,852,116
Pass
7
Total Budget Current Year
258,189,222
258,189,222
Pass
8
TY Quantity
3,903,265
3,903,265
Pass
9
LY Quantity
4,353,796
4,353,796
Pass
10
Budget Quantity
0
0
Pass

License Subreport : MLB PROPERTIES
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
40,711,995
40,711,995
Pass
2
Open
24,179,847
24,179,847
Pass
3
Total
64,891,842
64,891,842
Pass
4
Last Year
43,675,703
43,675,703
Pass
5
Budget
0
0
Pass
6
TY Quantity
2,685,510
2,685,510
Pass
7
LY Quantity
2,871,581
2,871,581
Pass
8
Budget Quantity
0
0
Pass

Customer Segment Subreport : TASTEMAKER
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
278,712
278,712
Pass
2
Open
104,292
104,292
Pass
3
Total
383,005
383,005
Pass
4
Last Year
225,477
225,477
Pass
5
Budget
0
0
Pass
6
TY Quantity
21,433
21,433
Pass
7
LY Quantity
15,419
15,419
Pass
8
Budget Quantity
0
0
Pass

Customer Subreport : LIDS INC
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
22,338,914
22,338,914
Pass
2
Open
18,552,987
18,552,987
Pass
3
Total
40,891,901
40,891,901
Pass
4
Last Year
22,016,939
22,016,939
Pass
5
Budget
0
0
Pass
6
TY Quantity
1,415,234
1,415,234
Pass
7
LY Quantity
1,370,792
1,370,792
Pass
8
Budget Quantity
0
0
Pass

Collection Subreport : CUSTOM
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
3,773,294
3,773,294
Pass
2
Open
10,684,855
10,684,855
Pass
3
Total
14,458,149
14,458,149
Pass
4
Last Year
6,491,738
6,491,738
Pass
5
Budget
0
0
Pass
6
TY Quantity
344,644
344,644
Pass
7
LY Quantity
824,258
824,258
Pass
8
Budget Quantity
0
0
Pass

Current Month Reports:
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Current Year Shipped MTD
26,036,698
26,036,698
Pass
2
Last Year Shipped MTD
30,501,571
30,501,571
Pass
3
Budget Current Year MTD
33,406,753
33,406,753
Pass
4
TY Quantity Current Year MTD
1,796,501
1,796,501
Pass
5
LY Quantity Last Year MTD
2,049,694
2,049,694
Pass
6
Budget Quantity Current Year MTD
0
0
Pass

License Month Subreport : MLB PROPERTIES
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
20,689,352
20,689,352
Pass
2
Open
358,045
358,045
Pass
3
Total
21,047,397
21,047,397
Pass
4
Last Year
22,977,079
22,977,079
Pass
5
Budget
0
0
Pass
6
TY Quantity
1,414,206
1,414,206
Pass
7
LY Quantity
1,402,661
1,402,661
Pass
8
Budget Quantity
0
0
Pass

Customer Segment Month Subreport : TASTEMAKER
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
40,230
40,230
Pass
2
Open
0
0
Pass
3
Total
40,230
40,230
Pass
4
Last Year
105,970
105,970
Pass
5
Budget
0
0
Pass
6
TY Quantity
2,608
2,608
Pass
7
LY Quantity
7,412
7,412
Pass
8
Budget Quantity
0
0
Pass

Customer Month Subreport : LIDS INC
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
11,332,791
11,332,791
Pass
2
Open
36,736
36,736
Pass
3
Total
11,369,527
11,369,527
Pass
4
Last Year
13,079,668
13,079,668
Pass
5
Budget
0
0
Pass
8
TY Quantity
729,385
729,385
Pass
9
LY Quantity
744,963
744,963
Pass
10
Budget Quantity
0
0
Pass

Collection Month Subreport : CUSTOM
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
2,252,737
2,252,737
Pass
2
Open
115,990
115,990
Pass
3
Total
2,368,728
2,368,728
Pass
4
Last Year
2,405,580
2,405,580
Pass
5
Budget
0
0
Pass
8
TY Quantity
189,140
189,140
Pass
9
LY Quantity
298,576
298,576
Pass
10
Budget Quantity
0
0
Pass

Third Level Check


Test Conducted

Group: North America > 5950 > United States Sales
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Current Year Shipped YTD
54,015,366
54,015,366
Pass
2
Last Year Shipped YTD
55,594,765
55,594,765
Pass
3
Current Year Budget YTD
68,650,667
68,650,667
Pass
4
Total Open Revenue
36,966,365
36,966,365
Pass
5
Total Shipped Current Year
90,981,731
90,981,731
Pass
6
Total Shipped Last Year
208,409,880
208,409,880
Pass
7
Total Budget Current Year
0
0
Pass
8
TY Quantity
3,704,324
3,704,324
Pass
9
LY Quantity
4,096,068
4,096,068
Pass
10
Budget Quantity
0
0
Pass

License Subreport : MLB PROPERTIES
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
38,254,685
38,254,685
Pass
2
Open
21,842,977
21,842,977
Pass
3
Total
60,097,663
60,097,663
Pass
4
Last Year
40,724,851
40,724,851
Pass
5
Budget
0
0
Pass
6
TY Quantity
2,532,150
2,532,150
Pass
7
LY Quantity
2,665,241
2,665,241
Pass
8
Budget Quantity
0
0
Pass

Customer Segment Subreport : GOLDSTAR
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
2,968,552
2,968,552
Pass
2
Open
2,051,107
2,051,107
Pass
3
Total
5,019,659
5,019,659
Pass
4
Last Year
3,055,784
3,055,784
Pass
5
Budget
0
0
Pass
6
TY Quantity
202,711
202,711
Pass
7
LY Quantity
205,103
205,103
Pass
8
Budget Quantity
0
0
Pass

Customer Subreport : AMAZON COM INC
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
619,115
619,115
Pass
2
Open
6,531
6,531
Pass
3
Total
625,646
625,646
Pass
4
Last Year
236,457
236,457
Pass
5
Budget
0
0
Pass
6
TY Quantity
27,219
27,219
Pass
7
LY Quantity
15,011
15,011
Pass
8
Budget Quantity
0
0
Pass

Collection Subreport : CUSTOM
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
3,429,579
3,429,579
Pass
2
Open
9,963,923
9,963,923
Pass
3
Total
13,493,502
13,493,502
Pass
4
Last Year
6,251,509
6,251,509
Pass
5
Budget
0
0
Pass
6
TY Quantity
325,549
325,549
Pass
7
LY Quantity
806,523
806,523
Pass
8
Budget Quantity
0
0
Pass

Current Month Reports:
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Current Year Shipped MTD
24,344,053
24,344,053
Pass
2
Last Year Shipped MTD
28,421,218
28,421,218
Pass
3
Budget Current Year MTD
31,255,254
31,255,254
Pass
4
TY Quantity Current Year MTD
1,679,167
1,679,167
Pass
5
LY Quantity Last Year MTD
1,907,580
1,907,580
Pass
6
Budget Quantity Current Year MTD
0
0
Pass

License Month Subreport : Others
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
975,869
975,869
Pass
2
Open
60,973
60,973
Pass
3
Total
1,036,842
1,036,842
Pass
4
Last Year
2,210,920
2,210,920
Pass
5
Budget
0
0
Pass
8
TY Quantity
81,484
81,484
Pass
9
LY Quantity
267,253
267,253
Pass
10
Budget Quantity
0
0
Pass

Customer Segment Month Subreport : GOLDSTAR
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
1,172,763
1,172,763
Pass
2
Open
60,896
60,896
Pass
3
Total
1,233,659
1,233,659
Pass
4
Last Year
1,212,019
1,212,019
Pass
5
Budget
0
0
Pass
6
TY Quantity
84,154
84,154
Pass
7
LY Quantity
82,566
82,566
Pass
8
Budget Quantity
0
0
Pass

Customer Month Subreport : Others
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
11,238,821
11,238,821
Pass
2
Open
170,577
170,577
Pass
3
Total
11,409,399
11,409,399
Pass
4
Last Year
13,676,691
13,676,691
Pass
5
Budget
0
0
Pass
8
TY Quantity
820,095
820,095
Pass
9
LY Quantity
1,042,599
1,042,599
Pass
10
Budget Quantity
0
0
Pass

Collection Month Subreport : CUSTOM
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
2,203,279
2,203,279
Pass
2
Open
115,990
115,990
Pass
3
Total
2,319,270
2,319,270
Pass
4
Last Year
2,257,930
2,257,930
Pass
5
Budget
0
0
Pass
8
TY Quantity
185,126
185,126
Pass
9
LY Quantity
287,562
287,562
Pass
10
Budget Quantity
0
0
Pass

Reference Document(Specification)


2013-03-15 - 5910.200 - Spec - Contract Reports